KS_INVENTORY

1

Part Number

string

25

Y

2

Site ID

string

5

Y

This field will also be used to create new warehouse/plant locations (Foreign Key Rows) automatically

3

Site Name

string

50

Only used if new warehouse/plant is created

4

Inventory
Location

string

10

Y

This field will also be used to create new inventory locations (Foreign Key rows) automatically

5

Location Name

string

50

Only used if new inventory location created

6

Quantity On Hand

decimal

14,4